<?php
include ('mysql.php');
include ('functions.php');
$server=mysql_escape_string($_GET['ip']);
//$query = "SELECT `status`,`port`,`transcode`,`stat`,`tarif`,`cloud_service` FROM `orders` WHERE `serverip`='$server' ORDER BY `port`";
$query="SELECT u.status, u.port, u.transcode, u.stat, u.tarif, u.cloud_service, d.alias
FROM orders u
INNER JOIN public d ON u.id = d.orderid
WHERE u.serverip='{$server}' ORDER BY u.port";
$sql = mysql_query($query) or die(mysql_error());
while($data=mysql_fetch_array($sql))
{
  echo $data['status']." - ".$data['port']." - ".$data['transcode']." - ".$data['stat']." - ".$data['tarif']." - ".$data['cloud_service']." - ".$data['alias']."<br>";
}


?>